BEGIN TRAN

USE [Product]  /* change to your project DB */

GO
/****** Object:  Table [dbo].[ServicesArticle] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PublishingArticle](
	[ArticleId] [smallint] IDENTITY(1,1) NOT NULL,
	[Code] [nvarchar](150) NOT NULL,
	[Title] [nvarchar](250) NOT NULL,
	[Description] [nvarchar](700) NOT NULL,
	[Text] [nvarchar](max) NOT NULL,
    [IsVisible] [bit] NOT NULL,
	[ArticleCategoryId] [tinyint] NOT NULL,
	[ArticleGroupId] [tinyint] NOT NULL,
    [CreationDate] [smalldatetime] NOT NULL,
	[ReleaseDate] [smalldatetime] NULL,
	[LastUpdateDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_ServicesArticle] PRIMARY KEY CLUSTERED 
(
	[ArticleId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

--ROLLBACK TRAN
COMMIT TRAN